********************************************************************************************************************************
***   Replication file for:                                                                                                  ***
***   Berbee, P., Braun, S. T. and Franke, R. (2024). Reversing Fortunes of German Regions, 1926-2019. JoEG.			     ***
***   							                                                                                             ***
***   SCRIPT: 	_x2g_preparation_census_1961.do																				 ***	
***   PURPOSE: 	Reads in and prepares data from the 1961 occupation and population census								 	 ***
********************************************************************************************************************************

* Preamble (unnecessary when executing run.do)
run "$reversing/scripts/programs/_config.do"

************
* Code begins
************

*** Import data

*** Occupation census 

import excel "$reversing/data/Expellees_1961.xlsx", sheet("Data") first clear

rename Sheet1__La labor_market_id

label var sbz_1961 "Total GDR refugees 6/6/1961"

** Save data

keep labor_market_id sbz_1961
destring labor_market_id, replace
sort labor_market_id

save "$reversing/processed/intermediate/sbz_census1961.dta",replace



*** EOF



